﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="view_list_staff.aspx.cs" Inherits="view_list_staff" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div align="center"><br /><br /><br />
    <img src="Image/view-list-staff.png" alt=""/><br /><br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="orclDataSource1" AllowPaging="True" AllowSorting="True" 
            Width="700px" ForeColor="#FFCC66" BorderColor="#4A1106" PageSize="20" >
        <Columns>
            <asp:BoundField DataField="PRENAME" HeaderText="PRENAME" 
                SortExpression="PRENAME" />
            <asp:BoundField DataField="STAFF_ID" HeaderText="STAFF_ID" 
                SortExpression="STAFF_ID" />
            <asp:BoundField DataField="STAFF_FNAME" HeaderText="STAFF_FNAME" 
                SortExpression="STAFF_FNAME" />
            <asp:BoundField DataField="STAFF_LNAME" HeaderText="STAFF_LNAME" 
                SortExpression="STAFF_LNAME" />
            <asp:BoundField DataField="STAFF_TEL" HeaderText="STAFF_TEL" 
                SortExpression="STAFF_TEL" />
            <asp:BoundField DataField="STAFF_PWD" HeaderText="STAFF_PWD" 
                SortExpression="STAFF_PWD" />
        </Columns>
        <HeaderStyle BackColor="#993300" />
        <PagerStyle HorizontalAlign="Center" />
        <RowStyle HorizontalAlign="Center" />
    </asp:GridView>



    <asp:SqlDataSource ID="orclDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString7 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString7.ProviderName %>" 
        SelectCommand="SELECT PRENAMES.PRENAME, STAFFS.STAFF_ID, STAFFS.STAFF_FNAME, STAFFS.STAFF_LNAME, STAFFS.STAFF_TEL, STAFFS.STAFF_PWD FROM PRENAMES INNER JOIN STAFFS ON PRENAMES.PRENAME_ID = STAFFS.PRENAME_ID">
    </asp:SqlDataSource>

            <asp:Button ID="Button5" runat="server" BackColor="#FFCC66" 
                BorderColor="#FF9966" Height="25px" onclick="Back_Click" Text="&lt;&lt; Back" 
                Width="85px" />

    <br /><br /><br /><br />

</div>
</asp:Content>

